#!/usr/bin/ruby
require 'rubygems'
require 'dbaccess.rb'
require 'mysql'

dbobj = DbAccess.new("localhost", "cgp", "sprinkler", "smdata")
dbobj.mycon = dbobj.connect()
dbobj.mycon.select_db("smdata")
dbobj.createcorr()
dbobj.mycon.close()
dbobj.loadcorrelationdata("/Users/cpadwick/workspace/sm-utils/data/corr_data/")
#dbobj.createnew()
#dbobj.loadsymbols("/Users/cpadwick/workspace/sm-utils/data/NASDAQ.txt", "NASDAQ")
#dbobj.loadsymbols("/Users/cpadwick/workspace/sm-utils/data/NYSE.txt", "NYSE")

#dbobj.loadhistoricaldata("01/01/2011", "NASDAQ")


